██ ██ ██ ██ ██████ ██ ██████ ██ ██ ███████ ██████ ██ ██
██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██
████ ██ ██ ██ ███ ██ ██ ██ ██ ██ █████ ██████ ████
██ ██ ██ ██ ██ ██ ██ ▄▄ ██ ██ ██ ██ ██ ██ ██
██ ██████ ██████ ██ ██████ ██████ ███████ ██ ██ ██
▀▀
Cards - Execution started 05/02/2024 05:02 UTC
By Guilherme Ruiz
By Guilherme Ruiz
Table of Contents ¶
- 1 Data aquisition
- 2 Check changes
- 3 Data visualization
- 3.1 Full data
- 3.2 Card types
- 3.3 Monsters
- 3.4 Spell & Trap
- 3.5 Effect type
- 3.6 Archseries
- 3.7 Artworks
- 3.8 Errata
- 3.9 TCG & OCG status
- 4 Extras
- 5 Epilogue
Data aquisition¶
Fetch online data¶
Downloading monsters
8393 results
Downloading Spells
2549 results
Downloading Traps
1911 results
Downloading tokens
165 results
Downloading counters
15 results
Downloading all errata
/home/jovyan/yugiquery/source/yugiquery.py:2381: FutureWarning: Downcasting object dtype arrays on .fillna, .ffill, .bfill is deprecated and will change in a future version. Call result.infer_objects(copy=False) instead. To opt-in to the future behavior, set `pd.set_option('future.no_silent_downcasting', True)`
pd.concat([errata_df, errata_series], axis=1).fillna(False).sort_index()
/home/jovyan/yugiquery/source/yugiquery.py:2381: FutureWarning: Downcasting object dtype arrays on .fillna, .ffill, .bfill is deprecated and will change in a future version. Call result.infer_objects(copy=False) instead. To opt-in to the future behavior, set `pd.set_option('future.no_silent_downcasting', True)`
pd.concat([errata_df, errata_series], axis=1).fillna(False).sort_index()
5069 results
Merge data¶
Data merged
Check changes¶
Load previous data¶
cards file loaded
Generate changelog¶
/home/jovyan/yugiquery/source/yugiquery.py:1101: FutureWarning: A value is trying to be set on a copy of a DataFrame or Series through chained assignment using an inplace method.
The behavior will change in pandas 3.0. This inplace method will never work because the intermediate object on which we are setting values always behaves as a copy.
For example, when doing 'df[col].method(value, inplace=True)', try using 'df.method({col: value}, inplace=True)' or df[col] = df[col].method(value) instead, to perform the operation inplace on the original object.
changelog["_merge"].replace(
/home/jovyan/yugiquery/source/yugiquery.py:1101: FutureWarning: The behavior of Series.replace (and DataFrame.replace) with CategoricalDtype is deprecated. In a future version, replace will only be used for cases that preserve the categories. To change the categories, use ser.cat.rename_categories instead. changelog["_merge"].replace(
| Password | Archseries | OCG status | Artwork | Modification date | Errata | Version | |
|---|---|---|---|---|---|---|---|
| Name | |||||||
| Loading... (need help?) |
Changelog saved
Save data¶
Data saved
Data visualization¶
Full data¶
| Name | Password | Card type | Property | Archseries | Effect type | TCG status | OCG status | Page name | Page URL | Artwork | Modification date | Errata | Attribute | Primary type | Secondary type | Monster type | DEF | Pendulum Scale | Link | Link Arrows | ATK | Level/Rank |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading... (need help?) |
Full data available to download here
Card types¶
Total number of card types:
3
Monsters¶
Attributes¶
Total number of attributes:
7
| Name | Password | Archseries | Primary type | Secondary type | Monster type | Effect type | DEF | Pendulum Scale | Link | Link Arrows | ATK | Level/Rank | TCG status | OCG status | Artwork | Modification date | Errata | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Attribute | ||||||||||||||||||
| Loading... (need help?) |
Primary types¶
Total number of primary types:
7
| Name | Password | Archseries | Attribute | Secondary type | Monster type | Effect type | DEF | Pendulum Scale | Link | Link Arrows | ATK | Level/Rank | TCG status | OCG status | Artwork | Modification date | Errata | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Primary type | ||||||||||||||||||
| Loading... (need help?) |
Has effect discrimination¶
| Has effect | Effect | No Effect |
|---|---|---|
| Primary type | ||
| Loading... (need help?) |
Obs: Normal monster can have effect if it is pendulum
Is pendulum discrimination¶
| Is Pendulum | Pendulum | Not Pendulum |
|---|---|---|
| Primary type | ||
| Loading... (need help?) |
By attribute¶
| Attribute | DARK | DIVINE | EARTH | FIRE | LIGHT | WATER | WIND |
|---|---|---|---|---|---|---|---|
| Primary type | |||||||
| Loading... (need help?) |
Secondary types¶
Total number of secondary types:
6
| Name | Password | Archseries | Attribute | Primary type | Monster type | Effect type | DEF | Pendulum Scale | ATK | Level/Rank | TCG status | OCG status | Artwork | Modification date | Errata | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Secondary type | ||||||||||||||||
| Loading... (need help?) |
By attribute¶
| Attribute | DARK | EARTH | FIRE | LIGHT | WATER | WIND |
|---|---|---|---|---|---|---|
| Secondary type | ||||||
| Loading... (need help?) |
By secondary type¶
| Secondary type | Flip monster | Gemini monster | Spirit monster | Toon monster | Tuner monster | Union monster | All |
|---|---|---|---|---|---|---|---|
| Primary type | |||||||
| Loading... (need help?) |
Monster types¶
Total number of monster types:
26
| Name | Password | Archseries | Attribute | Primary type | Secondary type | Effect type | DEF | Pendulum Scale | Link | Link Arrows | ATK | Level/Rank | TCG status | OCG status | Artwork | Modification date | Errata | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Monster type | ||||||||||||||||||
| Loading... (need help?) |
By Attribute¶
| Attribute | DARK | DIVINE | EARTH | FIRE | LIGHT | WATER | WIND |
|---|---|---|---|---|---|---|---|
| Monster type | |||||||
| Loading... (need help?) |
By primary type¶
| Primary type | Effect Monster | Fusion Monster | Link Monster | Normal Monster | Ritual Monster | Synchro Monster | Xyz Monster | nan |
|---|---|---|---|---|---|---|---|---|
| Monster type | ||||||||
| Loading... (need help?) |
By secondary type¶
| Secondary type | Flip monster | Gemini monster | Spirit monster | Toon monster | Tuner monster | Union monster | nan |
|---|---|---|---|---|---|---|---|
| Monster type | |||||||
| Loading... (need help?) |
ATK¶
Total number of ATK values:
83
| Name | Password | Archseries | Attribute | Primary type | Secondary type | Monster type | Effect type | DEF | Pendulum Scale | Link | Link Arrows | Level/Rank | TCG status | OCG status | Artwork | Modification date | Errata | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ATK | ||||||||||||||||||
| Loading... (need help?) |
DEF¶
Total number of DEF values:
78
| Name | Password | Archseries | Attribute | Primary type | Secondary type | Monster type | Effect type | Pendulum Scale | Link | Link Arrows | ATK | Level/Rank | TCG status | OCG status | Artwork | Modification date | Errata | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DEF | ||||||||||||||||||
| Loading... (need help?) |
Level/Rank¶
| Name | Password | Archseries | Attribute | Primary type | Secondary type | Monster type | Effect type | DEF | Pendulum Scale | ATK | TCG status | OCG status | Artwork | Modification date | Errata | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Level/Rank | ||||||||||||||||
| Loading... (need help?) |
ATK statistics¶
| ATK | ||||||||
|---|---|---|---|---|---|---|---|---|
| count | mean | std | min | 25% | 50% | 75% | max | |
| Level/Rank | ||||||||
| Loading... (need help?) | ||||||||
DEF statistics¶
| DEF | ||||||||
|---|---|---|---|---|---|---|---|---|
| count | mean | std | min | 25% | 50% | 75% | max | |
| Level/Rank | ||||||||
| Loading... (need help?) | ||||||||
Pendulum scale¶
| Name | Password | Archseries | Attribute | Primary type | Secondary type | Monster type | Effect type | DEF | ATK | Level/Rank | TCG status | OCG status | Artwork | Modification date | Errata | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Pendulum Scale | ||||||||||||||||
| Loading... (need help?) |
ATK statistics¶
| ATK | ||||||||
|---|---|---|---|---|---|---|---|---|
| count | mean | std | min | 25% | 50% | 75% | max | |
| Pendulum Scale | ||||||||
| Loading... (need help?) | ||||||||
DEF statistics¶
| DEF | ||||||||
|---|---|---|---|---|---|---|---|---|
| count | mean | std | min | 25% | 50% | 75% | max | |
| Pendulum Scale | ||||||||
| Loading... (need help?) | ||||||||
Level/Rank statistics¶
| Level/Rank | ||||||||
|---|---|---|---|---|---|---|---|---|
| count | mean | std | min | 25% | 50% | 75% | max | |
| Pendulum Scale | ||||||||
| Loading... (need help?) | ||||||||
Link¶
| Name | Password | Archseries | Attribute | Monster type | Effect type | Link Arrows | ATK | TCG status | OCG status | Artwork | Modification date | Errata | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Link | |||||||||||||
| Loading... (need help?) |
ATK statistics¶
| ATK | ||||||||
|---|---|---|---|---|---|---|---|---|
| count | mean | std | min | 25% | 50% | 75% | max | |
| Link | ||||||||
| Loading... (need help?) | ||||||||
Link Arrows¶
By combination¶
Total number of link arrow combinations:
63
| Name | Password | Archseries | Attribute | Monster type | Effect type | ATK | TCG status | OCG status | Artwork | Modification date | Errata | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Link Arrows | ||||||||||||
| Loading... (need help?) |
By unique¶
| Name | Password | Archseries | Attribute | Monster type | Effect type | Link | ATK | TCG status | OCG status | Artwork | Modification date | Errata | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Link Arrows | |||||||||||||
| Loading... (need help?) |
By link¶
| Link | 1 | 2 | 3 | 4 | 5 | 6 |
|---|---|---|---|---|---|---|
| Link Arrows | ||||||
| Loading... (need help?) |
Spell & Trap¶
Properties¶
Total number of properties:
9
| Name | Password | Archseries | Effect type | TCG status | OCG status | Artwork | Modification date | Errata | |
|---|---|---|---|---|---|---|---|---|---|
| Property | |||||||||
| Loading... (need help?) |
Effect type¶
Total number of effect types:
16
| Name | Password | Card type | Property | Archseries | TCG status | OCG status | Page name | Page URL | Artwork | Modification date | Errata | Attribute | Primary type | Secondary type | Monster type | DEF | Pendulum Scale | Link | Link Arrows | ATK | Level/Rank | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Effect type | ||||||||||||||||||||||
| Loading... (need help?) |
Card type discrimination¶
| Card type | Monster Card | Spell Card | Trap Card |
|---|---|---|---|
| Effect type | |||
| Loading... (need help?) |
Archseries¶
Total number of Archseries:
760
| Name | Password | Card type | Property | Effect type | TCG status | OCG status | Page name | Page URL | Artwork | Modification date | Errata | Attribute | Primary type | Secondary type | Monster type | DEF | Pendulum Scale | Link | Link Arrows | ATK | Level/Rank | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Archseries | ||||||||||||||||||||||
| Loading... (need help?) |
By card type¶
| Card type | Monster Card | Spell Card | Trap Card | All |
|---|---|---|---|---|
| Archseries | ||||
| Loading... (need help?) |
By primary type¶
| Primary type | Effect Monster | Fusion Monster | Link Monster | Normal Monster | Ritual Monster | Synchro Monster | Xyz Monster | All |
|---|---|---|---|---|---|---|---|---|
| Archseries | ||||||||
| Loading... (need help?) |
By secondary type¶
| Secondary type | Flip monster | Gemini monster | Spirit monster | Toon monster | Tuner monster | Union monster | All |
|---|---|---|---|---|---|---|---|
| Archseries | |||||||
| Loading... (need help?) |
By monster type¶
| Monster type | Aqua | Beast | Beast-Warrior | Creator God | Cyberse | Dinosaur | Divine-Beast | Dragon | Fairy | Fiend | Fish | Illusion | Insect | Machine | Plant | Psychic | Pyro | Reptile | Rock | Sea Serpent | Spellcaster | Thunder | Warrior | Winged Beast | Wyrm | Zombie | All |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Archseries | |||||||||||||||||||||||||||
| Loading... (need help?) |
By property¶
| Property | Continuous Spell Card | Continuous Trap Card | Counter Trap Card | Equip Spell Card | Field Spell Card | Normal Spell Card | Normal Trap Card | Quick-Play Spell Card | Ritual Spell Card | All |
|---|---|---|---|---|---|---|---|---|---|---|
| Archseries | ||||||||||
| Loading... (need help?) |
Artworks¶
Total number of cards with edited or alternate artworks:
700
| Name | Password | TCG status | OCG status | Artwork | |
|---|---|---|---|---|---|
| Loading... (need help?) |
By card type¶
| Card type | Monster Card | Spell Card | Trap Card |
|---|---|---|---|
| Artwork | |||
| Loading... (need help?) |
By primary type¶
| Primary type | Effect Monster | Fusion Monster | Link Monster | Normal Monster | Ritual Monster | Synchro Monster | Xyz Monster |
|---|---|---|---|---|---|---|---|
| Artwork | |||||||
| Loading... (need help?) |
More granularity is unnecessary
Errata¶
Total number of cards with errata:
4936
| Name | Password | TCG status | OCG status | Errata | |
|---|---|---|---|---|---|
| Loading... (need help?) |
| Name | Password | Card type | Property | Archseries | Effect type | TCG status | OCG status | Page name | Page URL | Artwork | Modification date | Attribute | Primary type | Secondary type | Monster type | DEF | Pendulum Scale | Link | Link Arrows | ATK | Level/Rank | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Errata | ||||||||||||||||||||||
| Loading... (need help?) |
By card type¶
| Card type | Monster Card | Spell Card | Trap Card |
|---|---|---|---|
| Errata | |||
| Loading... (need help?) |
By primary type¶
| Primary type | Effect Monster | Fusion Monster | Link Monster | Normal Monster | Ritual Monster | Synchro Monster | Xyz Monster |
|---|---|---|---|---|---|---|---|
| Errata | |||||||
| Loading... (need help?) |
More granularity is unnecessary
By artwork¶
| Errata | (Any,) | (Name,) | (Name, Type) | (Type,) |
|---|---|---|---|---|
| Artwork | ||||
| Loading... (need help?) |
TCG & OCG status¶
TGC status¶
Total number of TCG status:
6
| Name | Password | Card type | Property | Archseries | Effect type | OCG status | Artwork | Modification date | Errata | Attribute | Primary type | Secondary type | Monster type | DEF | Pendulum Scale | Link | Link Arrows | ATK | Level/Rank | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TCG status | ||||||||||||||||||||
| Loading... (need help?) |
By card type¶
| TCG status | Forbidden | Illegal | Limited | Not yet released | Semi-Limited |
|---|---|---|---|---|---|
| Card type | |||||
| Loading... (need help?) |
By monster type¶
| TCG status | Forbidden | Illegal | Limited | Not yet released | Semi-Limited |
|---|---|---|---|---|---|
| Monster type | |||||
| Loading... (need help?) |
By archseries¶
| TCG status | Forbidden | Illegal | Limited | Not yet released | Semi-Limited | Unlimited | All |
|---|---|---|---|---|---|---|---|
| Archseries | |||||||
| Loading... (need help?) |
OCG status¶
Total number of OCG status:
6
| Name | Password | Card type | Property | Archseries | Effect type | TCG status | Artwork | Modification date | Errata | Attribute | Primary type | Secondary type | Monster type | DEF | Pendulum Scale | Link | Link Arrows | ATK | Level/Rank | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| OCG status | ||||||||||||||||||||
| Loading... (need help?) |
By card type¶
| OCG status | Forbidden | Illegal | Limited | Not yet released | Semi-Limited |
|---|---|---|---|---|---|
| Card type | |||||
| Loading... (need help?) |
By monster type¶
| OCG status | Forbidden | Illegal | Limited | Not yet released | Semi-Limited |
|---|---|---|---|---|---|
| Monster type | |||||
| Loading... (need help?) |
By archseries¶
| OCG status | Forbidden | Illegal | Limited | Not yet released | Semi-Limited | All |
|---|---|---|---|---|---|---|
| Archseries | ||||||
| Loading... (need help?) |
TCG vs. OCG status¶
| TCG status | Forbidden | Illegal | Limited | Not yet released | Semi-Limited | Unlimited | nan |
|---|---|---|---|---|---|---|---|
| OCG status | |||||||
| Loading... (need help?) |
Extras¶
Multiple secondary types¶
| Name | Password | Card type | Property | Archseries | Effect type | TCG status | OCG status | Page name | Page URL | Artwork | Modification date | Errata | Attribute | Primary type | Secondary type | Monster type | DEF | Pendulum Scale | Link | Link Arrows | ATK | Level/Rank | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading... (need help?) |
Not yet released¶
| Name | Password | Card type | Property | Archseries | Effect type | TCG status | OCG status | Page name | Page URL | Artwork | Modification date | Errata | Attribute | Primary type | Secondary type | Monster type | DEF | Pendulum Scale | Link | Link Arrows | ATK | Level/Rank | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading... (need help?) |
Counters and Tokens¶
| Name | Card type | Archseries | Attribute | Primary type | Monster type | Effect type | DEF | ATK | Level/Rank | TCG status | OCG status | Page name | Page URL | Artwork | Modification date | Errata |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading... (need help?) |
Page name differs from card name¶
| Name | Password | Card type | Property | Archseries | Effect type | TCG status | OCG status | Page name | Page URL | Artwork | Modification date | Errata | Attribute | Primary type | Secondary type | Monster type | DEF | Pendulum Scale | Link | Link Arrows | ATK | Level/Rank | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Loading... (need help?) |
Epilogue¶
Execution completed 05/02/2024 05:06 UTC
HTML export¶
Notebook saved to disk